SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001311s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 631311 LIMIT 1 [ RunTime:0.000429s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 631311 [ RunTime:0.002685s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (142507,1027791,676810,271165,161134,603638,837631,295024,278144,821943,996096,334805,445490,187379,65938,91107,300812,556389,947330,393472,610888,694135,1011405,221848,722768,529605,315978,641289,995599,951788,269452,823160,86401,426353,397722,88253,108949,260311,139736,647206,438578,401827,11250,58128,746832,997760,791785,644306,895958,1030491,384389,520958,991500,427751,155669,68987,854298,53645,202582,255872) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 631311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 631311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]