SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003413s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 173517 LIMIT 1 [ RunTime:0.000773s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 173517 [ RunTime:0.003165s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (919700,105131,860536,140572,317389,541969,329336,647609,628982,10899,709718,502638,441009,1006192,543805,131077,130090,476637,608189,756660,147123,462665,161654,903551,339737,33994,551501,1047684,808543,544278,548935,92272,70908,274968,357355,478104,579688,189989,132063,828024,567280,1016459,366198,857429,371655,371961,263655,641613,476508,840094,952334,687622,283418,126324,49280,857721,196134,412495,343979,549723) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001318s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 173517 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001906s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 173517 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004953s ]