SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 710728 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 710728 [ RunTime:0.003969s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (201787,920246,761945,63282,335802,1044079,718201,752796,303209,764545,239227,1045119,667781,346209,1043687,790880,963908,731001,302844,196928,638110,605554,666929,180033,910417,390509,36118,329169,638207,618311,856099,18238,59292,897191,303215,972377,813358,980011,411827,120615,718360,908888,481230,464079,753409,325626,38526,192948,1000961,428173,7462,616705,171393,124017,673984,721586,924813,534325,28048,641367) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 710728 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 710728 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000411s ]