SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001393s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 345081 LIMIT 1 [ RunTime:0.002154s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 345081 [ RunTime:0.002963s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (952648,693414,329292,633148,1020488,309742,393009,572668,742784,210620,808736,573845,817243,357858,996265,794931,401715,513504,480618,150657,391120,490344,670767,546926,483895,499490,694716,842048,974497,519122,329556,46270,95974,987187,249150,999592,540706,611304,910982,569931,502117,741329,235420,1005013,78987,717524,615249,153262,443451,241337,627501,831646,828860,1003493,810612,559306,641470,796051,190164,64489) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 345081 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000904s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 345081 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001888s ]