SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 464711 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 464711 [ RunTime:0.003094s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (107241,898463,577675,626866,499890,118123,774040,597313,151896,533261,653773,390381,872369,565916,170300,158759,25973,1007812,190116,152337,607660,87393,574878,876063,1042909,775651,756929,378489,143675,271505,528772,509715,605912,103455,855517,709935,196776,421520,813896,582977,781654,852938,32420,260963,133780,731311,605989,501665,1002865,342900,112525,910507,991635,946622,393530,918816,747701,722722,160232,93920) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001611s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 464711 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000589s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 464711 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]