SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001323s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 593415 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 593415 [ RunTime:0.001899s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (215107,311003,439929,124309,771254,359222,264875,983415,1010188,552217,931626,23917,449049,290122,348596,658355,234161,237900,812636,93914,467064,210128,447434,38642,951658,123481,797675,428573,321843,112730,543682,1011326,1039713,958820,779640,955606,457801,30490,654660,704390,175758,222361,316537,518444,463737,1019288,367179,5949,630427,48270,415960,907325,350128,270071,371477,83482,236117,175541,849032,950509) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 593415 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000526s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 593415 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000635s ]