SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001530s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023102 LIMIT 1 [ RunTime:0.000695s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023102 [ RunTime:0.001899s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (567839,741346,453770,231865,996352,109318,960554,779318,522359,323602,575697,423986,63132,407655,17047,250733,179480,1008040,913160,981413,904680,623653,388660,845037,383625,952976,771865,825960,260308,469848,858293,756750,385521,519024,221693,744731,954461,931230,175458,516055,816992,370701,45908,712163,359962,283948,611605,1033626,39202,986892,283901,1024304,166014,272005,946673,458302,348417,1014718,266250,986960) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023102 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023102 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]