SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001295s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 195283 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 195283 [ RunTime:0.001564s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (529173,859066,705389,599211,22414,82881,534451,396288,722606,369053,910661,594516,961849,251929,409363,850240,658101,283734,396686,902625,778147,853296,328341,662555,782625,901203,219253,35444,594720,768601,843006,971686,632668,949380,56179,46884,829182,45181,138620,927895,254181,612608,541174,70797,569010,116537,35604,1004355,732691,981861,404884,884716,322375,655173,924047,83545,389118,925675,792144,244032) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000994s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 195283 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 195283 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000636s ]