SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 442404 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 442404 [ RunTime:0.001574s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (895659,654614,394511,546112,528046,787180,834179,872013,336498,206933,848405,754681,821345,294782,535206,708730,345591,174376,937491,613322,125677,758422,197567,21034,838076,943233,986465,899796,246746,546860,1031205,288487,524770,562645,316355,1035515,719248,982381,235277,213523,349525,923964,562792,914008,299528,198756,1040080,99336,106070,114767,18772,409096,647151,971470,1047129,740644,90698,517153,997226,926551) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000975s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 442404 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 442404 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000402s ]