SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001390s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 449504 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 449504 [ RunTime:0.002100s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (284534,950030,302851,1007172,42872,626881,150526,747909,650042,496985,362648,481533,378147,353038,917035,249848,776028,606709,932106,693059,243393,764658,474414,90277,372072,665237,862275,455940,104054,679498,102049,555546,86851,508863,187329,131165,503193,39796,630367,134601,521842,354131,847166,92336,270089,527437,440943,169818,655247,581312,554654,352783,751321,873406,431101,92052,330739,460224,408929,925332) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 449504 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 449504 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002931s ]