SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001042s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1011806 LIMIT 1 [ RunTime:0.001567s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1011806 [ RunTime:0.006300s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (739159,491018,752006,490523,287161,892092,456413,119153,824403,547873,790808,301199,129060,25532,328624,326550,581131,612292,989911,689622,21953,510362,166749,1030122,482129,892935,233236,462680,179648,385878,536118,498965,1031280,44280,500995,802691,643770,847119,14747,166000,861635,810355,473100,140534,702392,814675,197535,166769,95362,774619,775189,258304,184350,286168,798990,675237,486895,48943,750280,674385) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001310s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1011806 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1011806 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000507s ]