SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001442s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004636 LIMIT 1 [ RunTime:0.000658s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004636 [ RunTime:0.001827s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (336568,551947,206372,1020489,148118,836246,884594,293054,979514,470462,46536,568383,993010,638183,639896,798335,881669,177853,249402,200412,231941,684715,445481,91011,962019,524008,224629,437482,277860,237625,1005100,106040,978286,47676,412259,317582,23987,407619,265050,143304,90652,328226,999382,788985,68962,351285,993820,61724,766159,175872,512755,644322,102844,646783,905489,1023108,430390,801601,91605,541852) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004636 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000653s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004636 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000360s ]