SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 553640 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 553640 [ RunTime:0.001630s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (410708,165384,872006,71143,872331,504041,124409,395903,729539,402970,970164,979816,244768,357739,810483,647176,97786,668061,315006,57986,349534,862487,545473,3894,838707,152240,1032093,40990,401940,661668,456731,891041,558769,561257,765425,189115,245444,294842,190900,666224,835044,910155,265139,120432,289559,25385,608269,871198,317890,255097,1018658,547923,813413,547417,66266,802148,178303,652236,206021,574962) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 553640 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 553640 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]