SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 464380 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 464380 [ RunTime:0.001741s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (567525,1017864,1037015,534644,963750,849069,147525,335816,634359,875354,602100,946001,874598,483222,605084,1002228,337291,442377,777230,882435,968314,265982,409186,466214,284644,640415,588285,700846,381601,997540,411179,975222,741807,634300,759396,808437,564436,66794,544141,658599,196095,214448,812440,202081,1046168,337706,118574,677670,449887,934881,211773,257902,152821,865920,55354,313245,428063,583797,1034625,415222) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 464380 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000501s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 464380 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]