SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001371s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 449043 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 449043 [ RunTime:0.007425s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (555692,162467,374335,809951,381530,978133,145929,665495,735031,538970,398467,76117,507878,871927,487817,992806,591331,828101,293565,371643,834252,22961,129184,642802,947679,888283,500894,153592,1035769,639615,984293,633320,204153,294061,998402,1034419,158589,651826,317877,192403,549127,736717,974115,536855,184115,599140,424061,35112,196630,394271,586648,760068,585979,40636,468708,889043,39683,462012,610820,629119) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001863s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 449043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000526s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 449043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001799s ]