SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501038 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501038 [ RunTime:0.002302s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (121010,459200,594219,421046,1036975,420633,246345,563196,398370,656068,559961,7476,8687,339639,315722,417722,557056,325997,735882,617169,160779,170196,677421,615774,803739,950358,695335,213235,253025,936056,215549,45390,185658,1040308,239830,81961,930328,643579,114801,50328,11579,614281,461011,829884,173805,387129,607391,196293,468519,758233,52613,121163,420871,420585,148934,980738,803361,756316,654610,648871) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001868s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501038 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000693s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501038 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]