SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001375s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541210 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541210 [ RunTime:0.001739s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (664516,8554,187742,598321,74156,39555,691920,569724,1014961,894952,661742,481421,376569,288047,1031563,467295,947872,1029278,231256,713853,627058,210421,64677,687485,770153,192761,18125,779497,783700,112816,655628,832877,677176,206493,567293,782146,361803,704233,588862,583989,844431,228351,516859,771945,819966,836484,846471,84725,931922,509741,363038,28840,773002,561142,274935,986794,139221,320733,438702,373698) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000939s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541210 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541210 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000481s ]