SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 262856 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 262856 [ RunTime:0.001656s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (609809,467721,287571,857454,891586,621085,984107,921626,874565,50271,811087,281711,1000746,818680,554074,368238,249651,824141,556858,503619,306303,250399,626494,491871,174390,891249,527726,275929,606908,405060,867823,768302,223655,731369,944529,702334,564407,374986,892076,199322,616799,389118,778777,829115,788959,985504,666997,106075,583582,779005,342967,280216,39558,707563,162345,241473,866869,424380,835074,546841) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001063s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 262856 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 262856 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]