SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 116569 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 116569 [ RunTime:0.001689s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (501806,178649,96510,983491,1027189,81242,343280,286423,66915,1012766,99057,717636,165793,403178,273133,583979,860508,285055,819705,119513,899500,959064,195826,743510,635042,954456,497679,301845,1021069,1047117,614074,672004,364773,1037359,218780,775956,61859,624694,796613,464263,156812,248594,993178,816845,169986,630359,851304,317821,713533,428046,447201,630343,965064,106434,694092,60402,237700,491624,554863,987726) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004234s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 116569 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 116569 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000773s ]