SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414238 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414238 [ RunTime:0.002430s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (486271,496108,531147,909182,151758,149887,593237,1025264,85234,884070,217053,894830,984150,814447,97130,267480,919440,702655,109816,314692,1004317,51218,827937,679245,659149,41119,576703,134706,98175,776389,604113,968971,31741,664302,354166,341950,724132,944486,948187,547538,199284,654409,410357,406397,65673,412788,566935,85015,47017,515717,7038,708577,949500,493821,956643,583026,617042,834479,782949,693416) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001042s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414238 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414238 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000736s ]