SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 682313 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 682313 [ RunTime:0.001666s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (94106,904970,1001827,239898,738425,608889,842263,969433,68435,319959,270545,2900,460664,587519,338408,875430,146104,75142,789188,1011115,83434,689150,943137,746278,7481,110961,198943,536196,310903,878260,855881,373018,985108,988392,83052,79039,307151,109431,347346,368408,11588,634050,286005,632949,959441,874973,191982,336009,348692,227161,677975,245304,658924,694050,64306,575071,1047894,614798,701059,404814) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001886s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 682313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 682313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000587s ]