SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 346543 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 346543 [ RunTime:0.003840s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1018735,542246,874816,446021,239207,658504,519181,632302,58649,762033,370045,330684,244893,180396,399336,69063,315625,451064,552760,405867,738092,879230,225532,401774,582652,451823,463380,460260,158698,628417,182040,676978,232324,779559,601309,567490,680648,797062,535839,603044,387120,945112,583205,513636,792776,1018390,218461,427272,78984,433038,172012,484074,878526,218516,12460,397525,166548,335169,316632,52324) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 346543 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 346543 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]