SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027438 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027438 [ RunTime:0.001772s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (662808,782416,376661,256731,1010921,724242,791013,1037801,874873,391886,925196,873424,615823,549696,326181,926590,1008183,117182,228356,71830,229884,554543,439082,317916,100484,30382,316097,809301,851477,132024,453046,681510,372653,703604,1028545,348540,815714,302110,1027555,993916,900489,848256,786676,1047194,854989,906872,590802,1028000,97537,202559,470352,388870,328128,19288,125731,524912,33585,785265,456735,731795) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027438 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000631s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027438 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]