SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 121524 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 121524 [ RunTime:0.001626s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (21580,1016096,286393,515004,771851,153399,310404,495910,149774,899171,747228,466897,514341,27835,158825,176659,415448,909095,1028549,723622,77978,818645,117190,204971,810031,738868,864826,715536,116778,650757,725933,571773,175826,222114,332527,754539,432735,273474,179933,356404,691666,394660,180395,374366,401102,954181,926419,712548,411828,700692,946600,98131,69160,177108,921928,973275,904955,145417,228854,161152) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 121524 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001531s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 121524 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]