SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 919905 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 919905 [ RunTime:0.002872s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (593489,92567,56769,39508,555621,96759,134070,656506,1043228,729030,374792,932886,248103,867239,1042866,531743,118412,749074,110664,243929,536112,18199,76995,1018941,159711,18880,385824,882128,593713,834658,106065,438820,181375,361643,569003,235771,30239,664098,692500,40658,448805,81941,336719,677471,117145,952553,102332,975825,186311,187651,621411,31047,158765,108325,964224,77292,759775,29264,94288,545767) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001071s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 919905 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 919905 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000433s ]