SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 446929 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 446929 [ RunTime:0.004457s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (601821,752458,284600,572074,901159,73924,70753,239183,467818,895592,424138,332704,1040035,711573,174826,873717,268581,905859,309846,598498,103108,185095,54262,248293,15871,945373,253188,370137,209302,575473,873702,447778,687343,355130,448474,167446,704133,561885,664762,4287,13439,188910,102971,712928,985757,361709,745228,211787,184154,857800,1026464,399382,784529,992988,925395,221554,79446,566741,864857,392702) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 446929 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 446929 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]