SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 443417 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 443417 [ RunTime:0.001916s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1023984,922234,752039,812386,759989,316062,576590,608717,549270,502998,402728,382398,837577,128267,518345,851099,161321,892346,915481,672807,98565,993802,185539,284156,517508,17917,364631,265995,845324,87232,224317,997210,32157,88596,997821,406453,639262,501635,821413,767089,454087,677203,593780,507673,561129,446326,207419,976907,487748,345892,995992,576842,676942,976185,598434,605908,928631,269764,303655,645983) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 443417 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 443417 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000412s ]