SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535462 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535462 [ RunTime:0.001545s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (875089,71800,294382,840148,957533,724430,422306,19269,141208,648023,1044480,355653,344683,478387,483654,427656,771543,322292,656207,382041,946328,377834,796976,548680,445920,847285,254955,1019588,974231,1014809,488007,211282,80332,157658,253690,195478,964036,778289,937984,487487,612338,1043290,363575,296872,650957,322874,781294,351855,3222,141978,634528,292227,123502,1030305,645185,62011,224144,564412,422959,723711) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535462 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535462 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001486s ]