SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1030011 LIMIT 1 [ RunTime:0.000583s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1030011 [ RunTime:0.002052s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (77158,819642,725602,662900,415835,627884,176136,992735,878173,551099,113572,747413,344808,322119,432718,964873,244996,572960,767765,944302,159933,462164,816155,762108,587088,482815,329857,782869,165995,422955,704590,903769,177972,331186,167928,461530,450960,937363,12465,57333,960495,276218,719793,250115,382400,713324,648735,188697,792643,1035385,729379,497332,1031239,924625,806321,500019,118128,384134,319539,495927) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1030011 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000457s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1030011 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]