SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407111 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407111 [ RunTime:0.002261s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (498610,313924,112371,235428,575030,337390,806747,86071,348963,746401,750357,962818,38743,163942,61847,761585,3753,341476,1024611,791904,79037,972765,145512,491386,772145,527054,1026139,702654,113967,318932,999728,431732,500102,185786,457726,960260,739438,148450,382902,371549,331585,155971,379380,875663,737543,154651,965137,840551,189065,836345,873085,719574,615027,249778,819635,490835,295290,962581,576334,509552) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001919s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407111 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407111 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000795s ]