SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001373s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 521029 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 521029 [ RunTime:0.002253s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (252928,556905,1039782,194312,147510,953886,857720,551630,150620,777284,332779,209438,931812,304849,568497,918089,683381,669011,231238,335388,559478,329639,1000529,889066,762115,151455,418131,298720,605463,369899,152668,1026784,17370,676390,944079,594778,230679,729277,749023,510963,932741,813833,1010328,797355,42923,705314,780435,463126,912124,236289,840688,603599,999394,709245,941129,424086,488035,483783,760170,138845) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 521029 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 521029 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000622s ]