SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804441 LIMIT 1 [ RunTime:0.001188s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804441 [ RunTime:0.001808s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (773158,525508,43652,393468,82604,967235,721175,652153,442571,407977,744498,336441,282288,117721,679105,408492,752269,449357,100548,118142,554804,841569,1002320,597704,272832,827962,233514,173655,620969,739725,704580,916040,308162,153062,861160,8396,697634,259563,781456,710840,730688,382211,324023,338946,856438,709415,394753,46916,30004,416602,611897,852585,349471,921533,616830,277711,924060,248327,304529,859111) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804441 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804441 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]