SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001329s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 581583 LIMIT 1 [ RunTime:0.005127s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 581583 [ RunTime:0.009876s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (151047,425799,442179,146498,899627,426565,190399,824889,235777,143468,811688,61910,446451,615885,814239,108840,286845,740201,165377,939622,438896,1013987,321959,448517,230355,640908,636598,628586,899720,24176,987328,172331,117722,928648,122987,846802,718631,680672,178822,634080,131429,203336,1034506,517684,1017197,20437,802760,326362,244296,873612,284812,862609,916654,196771,200272,128307,664932,179885,72041,878869) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.008054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 581583 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004764s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 581583 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]