SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002262s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 530210 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 530210 [ RunTime:0.002190s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (260374,135194,319185,407670,81272,1020150,454574,662405,839833,885690,135357,374641,582545,279120,264939,303314,234453,381889,206285,600981,555369,316731,753695,246594,788770,214783,886342,166479,878459,135913,591669,431445,10859,947855,562294,385179,135449,500834,543129,466544,496020,169675,540330,947499,198639,392670,1034141,661798,460013,767010,605299,377719,111738,252245,730686,492679,347981,206192,427459,306017) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003945s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 530210 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 530210 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000671s ]