SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001367s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418972 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418972 [ RunTime:0.001717s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (457485,129236,805382,752925,587311,79839,239175,294455,44569,61635,679951,59099,222720,200728,699525,934808,685307,242428,852014,696197,787500,159323,576654,440643,218380,922540,771677,536569,87230,488272,1011773,996870,472159,604038,897904,402178,517102,9134,369720,914324,457600,508525,810486,601154,111932,151309,960046,353480,834169,794099,734927,164411,98628,17249,646505,346790,898450,413527,106477,107500) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418972 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418972 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000683s ]