SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 312580 LIMIT 1 [ RunTime:0.000434s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 312580 [ RunTime:0.001871s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (117558,617375,173650,532861,288858,1048830,976654,589784,348909,555591,456963,435355,204843,345559,403295,550488,620170,433160,285581,957655,922138,669649,629861,958358,221654,507123,983868,494772,593697,818298,491982,549782,288368,335642,31465,134414,374389,733325,1000128,111485,137466,244082,336661,929396,111921,489494,6598,542497,883483,74803,206458,8103,159645,482997,345393,616412,582387,944812,477871,143929) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 312580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 312580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]