SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001338s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 512516 LIMIT 1 [ RunTime:0.000856s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 512516 [ RunTime:0.002040s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (143928,50431,125448,682840,364434,916482,583575,264813,151744,284684,975116,863274,1011269,162028,912113,562998,678688,832640,691513,137924,94037,1033018,870933,750067,292675,94884,171670,202853,86096,98937,506612,294776,552135,1010665,574333,782935,562336,153627,742473,830604,561023,587815,233785,390239,245718,176740,614141,132274,104198,692548,998691,660339,1045443,205197,268652,595009,13910,369053,10194,797052) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001726s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 512516 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 512516 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000470s ]