SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001335s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201271 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201271 [ RunTime:0.004679s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (406300,252886,631227,909903,452307,443442,372325,541285,513039,24977,387742,654388,31847,341555,652828,986834,184818,380928,1017920,376036,419771,487409,510371,730166,244861,918135,715014,583497,24614,12081,973858,306338,791328,184109,334889,466350,358040,519516,369174,1043581,561666,864973,927409,685673,175858,329799,667743,808661,629151,840175,178945,763739,842580,503347,917462,635889,699333,63491,807718,705076) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201271 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000484s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201271 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001026s ]