SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 297071 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 297071 [ RunTime:0.001832s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1007209,596250,748240,785427,890497,391153,50387,988042,949551,230115,256297,792124,135426,558018,850771,42212,710244,769673,907197,375117,601809,124291,148580,877864,536833,446280,496427,54673,820424,303329,666144,353604,1026559,2002,768923,455703,857584,1040687,60541,184468,317012,256953,647108,342678,504128,845654,759659,507458,358576,854891,125608,831866,11515,182099,249034,895807,727898,516365,710520,710100) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 297071 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000508s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 297071 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000477s ]