SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 981730 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 981730 [ RunTime:0.002409s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (841029,467124,781117,834104,1015376,820052,629120,545261,719825,1045149,1010883,769226,349087,390591,271272,1016203,534942,125138,969017,475819,450109,436533,761746,10508,867659,994290,990380,908982,296879,949122,821539,531560,110131,568696,812157,878855,1011623,607067,108022,349802,217972,402364,777486,1013692,194282,849021,408248,626238,565808,725003,657845,328956,378338,458861,1045023,600328,550899,67459,531589,137836) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 981730 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 981730 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]