SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406867 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406867 [ RunTime:0.001815s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (530243,1022194,693108,56312,161446,535445,113525,39461,603141,162264,379115,382641,607251,937885,879499,352231,312294,921377,355289,112231,323116,288187,328810,1047695,230270,429305,346407,661176,405387,593197,806052,274273,727698,262214,403243,1005936,185208,991760,845386,881103,575932,944450,665969,116046,155352,876934,470395,592088,609565,667872,497183,837764,269563,803956,245995,864621,451853,816078,1011322,445459) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001071s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406867 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406867 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]