SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341738 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341738 [ RunTime:0.001734s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (33315,406735,1045827,143067,470757,752732,797153,934590,179238,198264,964998,530470,648200,1045117,359398,741412,260298,507440,638103,530871,296902,209630,606972,690525,938666,374823,27420,132872,161679,1026282,493803,222522,659752,665283,269663,222743,980221,9040,781489,997514,427885,497487,311247,558426,267849,338435,402442,19369,835664,866056,235366,400606,251322,322765,31412,160699,693023,667365,52688,152983) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341738 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341738 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]