SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 177211 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 177211 [ RunTime:0.001613s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (424357,837970,571270,77878,1032390,849771,321060,958,570793,625881,390688,150226,733869,507715,275892,478271,255685,317847,873514,701765,679605,769905,834180,335415,541317,73868,496319,808901,205498,995188,699527,388814,424131,649826,687024,160098,46294,560960,622150,202666,191359,971139,906297,869615,91328,842535,270722,11408,696932,344707,173572,546750,364477,861695,134849,763498,886338,378415,560521,923209) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 177211 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 177211 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]