SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504190 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504190 [ RunTime:0.001865s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (940315,295917,265484,109469,295056,202676,405620,195369,318516,919537,983181,674651,616339,835496,652314,847560,384643,441755,883241,415783,291164,661918,953904,48189,10540,728488,600160,978926,270125,197027,406897,227563,453764,994175,677920,511890,19147,840403,763997,463435,899444,921200,265589,320573,154160,177792,192408,133554,896494,516338,694813,142039,663250,739169,212208,165876,232849,642714,526410,389916) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000957s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504190 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504190 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000403s ]