SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002476s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509905 LIMIT 1 [ RunTime:0.000473s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509905 [ RunTime:0.002065s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (943600,561953,167301,1031228,1004147,657113,108236,983062,631569,531040,513074,982378,524039,514510,104023,282497,574949,434476,384823,378886,1019798,417717,383478,154176,308467,748414,37737,294856,164578,584021,887315,559381,459293,35530,216111,316668,194468,478324,809334,744068,74037,298434,727618,642071,334206,545014,464495,192430,202056,920566,873839,1311,396272,272063,1009333,223413,659399,933675,886374,860712) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509905 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509905 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000469s ]