SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538457 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538457 [ RunTime:0.001674s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (399466,590394,969708,640793,122175,919088,190211,299230,870433,60020,306039,1127,955473,403776,373507,550757,239595,329143,797788,486465,649789,114938,965471,45330,298945,670090,627932,653812,632860,778073,340486,157021,777242,617132,464381,586229,213085,368477,83852,563138,81178,938412,659368,911590,512715,293898,107683,122820,575870,197013,613559,67658,791777,1024597,695667,114396,678555,455494,300590,374041) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538457 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000457s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538457 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000706s ]