SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410530 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410530 [ RunTime:0.001980s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (900333,757012,414923,621902,862703,537860,882830,779464,567240,682647,156801,53155,175937,470206,933894,93567,992147,660261,360787,953520,762779,93823,248557,5201,712790,439019,910068,167682,271034,406223,196171,349739,325328,90923,759756,857561,139964,76837,375716,159187,241136,771780,268327,32457,301765,175750,96942,442070,776625,845290,528007,514791,798413,435817,298622,902357,883357,46719,243649,104322) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410530 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410530 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000413s ]