SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 671023 LIMIT 1 [ RunTime:0.000523s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 671023 [ RunTime:0.001625s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (362085,47895,366777,578225,302687,73254,453227,972328,521145,971254,337651,782335,753000,204509,204159,26426,528591,867200,913142,792395,403638,983312,936570,1033848,746415,331096,197575,1001857,204843,39105,317613,188190,314107,198818,400412,138052,314633,228189,419664,435218,776071,687134,301760,285854,141897,512345,315815,648730,197977,784703,352733,370045,886457,785405,645631,642068,622827,529225,367297,713236) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001509s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 671023 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 671023 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001165s ]