SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002560s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 6843 LIMIT 1 [ RunTime:0.001215s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 6843 [ RunTime:0.003075s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (971548,39058,773710,96808,275125,806011,1026314,55878,8514,99233,602677,481218,167945,496428,783643,202768,907096,861205,1001246,138892,47377,216401,211552,623401,610801,919768,443861,822496,282887,667759,580715,816076,969319,165074,703639,22730,709209,204907,196733,260980,176459,759787,952239,406357,1045904,754413,306806,260420,530457,567982,237832,6393,1038110,944544,661332,69770,868378,3679,470806,982052) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001720s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 6843 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000505s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 6843 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002707s ]