SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001796s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291330 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291330 [ RunTime:0.002421s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (445710,840385,1012616,215728,160847,463631,593718,939598,794585,851268,745551,309256,429589,116733,372782,426041,251239,332019,345169,960138,177460,805214,880589,123416,971771,672417,1043371,277765,801499,859295,260716,288934,71564,124817,1016186,741789,834564,384088,665325,966941,196939,1040311,182765,207397,872523,639732,70520,502490,297759,477787,167690,52594,473289,936397,170494,552137,324776,763318,699353,807037) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291330 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291330 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]