SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503951 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503951 [ RunTime:0.001688s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (466066,652644,180178,1020545,602545,976104,1045469,306583,1039622,70574,1024330,41331,285296,950686,1023487,432651,992395,477282,338722,433173,787059,882291,470328,13939,210020,362446,688896,425073,677494,771891,757940,283857,188454,553254,850275,881532,845674,133779,655655,293216,961785,806585,962908,392197,727156,170343,663507,121797,410066,219129,597574,530663,589060,720788,664139,431585,194025,662317,694529,29940) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000972s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503951 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503951 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]