SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029873 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029873 [ RunTime:0.001682s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (360177,36039,783845,314976,367384,758073,50899,1003219,642650,210012,992243,80133,151537,462467,427743,795507,216406,357857,97806,932786,274955,883072,75200,136661,888683,723792,177529,931128,456984,808689,837083,341833,966904,706483,93044,875401,292459,784924,144308,131011,47092,358128,749964,941015,114551,65260,434545,289308,790639,733717,856641,275158,970730,870229,81755,879180,267553,493589,390140,551183) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029873 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029873 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]