SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 981401 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 981401 [ RunTime:0.001817s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (819485,303067,366920,255793,5795,783174,536002,417365,485876,700868,821542,1038127,590841,745414,814107,277586,745182,289615,1034659,715672,434337,213302,924909,383707,423940,500417,1032503,2836,742654,87805,706321,676655,628969,132787,1013848,187275,737714,704110,209543,651201,630313,721278,33974,587068,399146,667177,91873,449650,286922,515794,713723,290878,19914,412711,1045554,930117,1020470,148118,259508,418323) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001002s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 981401 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 981401 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000468s ]