SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 492812 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 492812 [ RunTime:0.002215s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1001222,299718,492746,524380,212192,464361,252188,360623,361434,152480,843147,677933,964955,671937,718984,702929,794909,509590,66891,946625,64104,626768,550135,519113,81686,451860,1011524,764286,196755,469928,720584,283947,116716,507929,215223,1013691,458085,623952,267555,1022239,121041,341479,426433,178232,219320,10858,848872,1021570,151168,59322,54202,362842,839093,50164,344878,994232,632238,672412,724676,102860) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000965s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 492812 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 492812 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000431s ]