SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1009151 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1009151 [ RunTime:0.001476s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (281597,8972,685886,22975,480939,523670,246712,44902,233469,904394,920460,826442,1029330,348530,754523,497914,362655,108047,558957,870013,29077,52494,427776,670709,174345,621885,693043,500567,438167,444143,196164,104778,1038650,970798,641391,240743,418588,463096,150869,325341,767257,220750,231771,1048046,82120,988013,845232,1031558,126044,830176,85781,617145,566678,847471,696966,418044,150213,642441,504644,665031) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1009151 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1009151 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]