SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 369283 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 369283 [ RunTime:0.001460s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (166112,189890,300311,792136,415807,35825,728147,160941,480845,980764,624245,463439,631066,296692,838381,968979,737414,775250,282301,847093,39851,987567,120855,813814,832191,112451,342649,243729,681594,839883,450396,51211,477720,162715,672218,481004,357645,588353,184881,487518,94193,383099,269406,107110,812745,1038073,784417,83175,745229,677585,957467,1003241,149872,956872,858538,190011,247760,176555,259276,347216) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 369283 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 369283 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003832s ]