SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 84448 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 84448 [ RunTime:0.003347s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (674129,537643,752762,419713,573769,872292,879704,685118,552462,971357,913920,1010183,643651,357327,28166,916172,938584,933567,673215,98980,421064,846957,827134,144677,338960,1025341,324793,1043085,863008,590940,230675,991040,403393,708374,434012,651878,309870,907918,902654,770614,607010,803456,240781,390941,156824,232182,957248,135417,106063,179958,120895,987491,623221,755940,345729,973012,713596,192228,898368,680330) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 84448 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000472s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 84448 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]