SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1015107 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1015107 [ RunTime:0.001615s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (893872,1012980,175764,275722,443473,639084,276919,433727,697787,443475,241146,1015108,518793,22681,101890,48740,51741,952380,1004956,474237,755744,160429,813799,384497,636952,1016195,947988,559579,368960,557390,470167,255190,540826,287239,300762,998014,916408,449099,561175,1008279,316919,534379,820896,699552,534906,540467,576124,190031,940843,371719,777310,623969,519280,411750,553199,269600,791143,985160,31020,524819) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001550s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1015107 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1015107 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]