SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 831091 LIMIT 1 [ RunTime:0.002370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 831091 [ RunTime:0.002206s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (350718,416963,225640,1019531,693956,258735,378020,801121,265036,230224,368670,504836,35671,264285,889610,271936,702364,639807,642616,1027107,210074,652222,415404,511523,708869,862584,369813,764507,133998,51469,121726,86883,1018868,171165,921743,939370,938856,208346,873473,513397,286832,656512,315482,3951,856448,533318,888621,407361,677872,514617,502997,449161,885530,37294,368946,327714,177105,438567,255682,840865) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 831091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 831091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002209s ]