SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001407s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039767 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039767 [ RunTime:0.002896s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (452895,924968,292807,350271,330295,284105,663638,70439,565513,764332,741243,100492,682922,821714,604231,676144,655695,453253,141728,786233,729838,466918,528987,694116,122787,51595,779671,601995,791006,412374,517466,646848,88865,194071,504179,565234,250071,927306,527205,153398,659944,359649,918454,864197,85208,180657,1002660,384965,312979,742905,970255,206212,630119,167754,145540,401584,944358,764772,541953,624108) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039767 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039767 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000640s ]