SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001468s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 298570 LIMIT 1 [ RunTime:0.000497s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 298570 [ RunTime:0.001989s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (556821,125028,185817,856798,896361,1025649,445057,550866,702649,330788,306984,708931,562265,225838,355890,274584,746414,439108,902845,556672,730993,231270,674949,10640,505274,504443,978847,844495,959997,91036,661469,579401,568724,871298,86214,997470,649997,967141,422526,441905,894391,678707,429529,88020,351411,842112,28267,847860,530381,981395,422057,83211,720348,519789,980915,19071,537596,299666,311283,1021548) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001594s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 298570 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000566s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 298570 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000616s ]