SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532500 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532500 [ RunTime:0.001561s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (127918,484991,91373,114481,133262,122810,480594,765257,801288,404193,942611,205034,393844,691241,120729,771398,333251,889812,1001481,992796,1013914,887519,1018159,334899,207448,189505,279086,804852,251333,624868,325609,660920,485671,18747,684687,796372,450097,307185,152766,594472,625134,146925,421165,152936,948908,977802,135891,758764,18067,499971,740385,426297,391859,757213,490185,328204,245856,316220,662424,750745) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000975s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532500 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532500 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]