SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 42003 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 42003 [ RunTime:0.001473s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (954654,52535,704195,575419,249418,471861,229654,183906,555266,192208,214493,142469,54120,452827,1045690,102881,552004,389060,652424,328041,723013,170986,476007,425391,491293,769013,9036,807779,334960,68856,791533,546515,805251,420358,1009138,609779,330213,177189,978894,1007798,508170,195873,931006,565914,6539,633794,7621,611586,477494,867548,430715,37587,1032681,194126,1009762,383534,343143,713540,181096,586076) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 42003 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 42003 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000720s ]