SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003309s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031498 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031498 [ RunTime:0.001775s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (194052,575027,414878,173680,277860,282433,371475,592761,70855,717959,999204,612026,1010205,812934,667983,689471,705118,987308,297371,249159,915901,640567,117169,945516,39337,653869,849689,802730,885835,802204,493830,525920,614555,680190,483309,767299,697458,299836,402071,739521,592436,228497,534332,745794,133002,550311,908412,500606,986232,207072,151387,260173,975238,753330,191985,357793,874558,929298,446994,975842) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031498 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000530s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031498 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]