SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291564 LIMIT 1 [ RunTime:0.000473s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291564 [ RunTime:0.001665s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (622935,20240,308233,284901,724868,263961,502683,317710,314418,739361,846962,552830,864853,317668,733416,544399,326941,228169,649207,597435,244650,530137,813545,811700,955552,513206,108308,987171,436905,828288,736746,10031,890573,601952,54816,720188,576402,897896,615015,935698,738360,191719,802630,998404,930552,901843,351951,117732,86349,748244,147628,148721,963717,478953,748078,783631,37595,305336,991962,968088) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000986s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291564 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291564 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]