SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 671121 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 671121 [ RunTime:0.001558s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (21893,107158,1036790,832890,665483,563070,85619,721252,757924,559775,472577,115077,347631,699130,219516,130017,194014,775104,1011469,390530,1035082,657304,312572,764050,182992,641201,399333,661102,243152,998253,691316,853205,299966,878492,676434,714403,826894,233568,26299,865138,587779,139141,661420,671720,388023,43852,825338,663067,540086,635180,741336,496722,958339,1003556,874914,587120,36465,130083,730896,847254) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001868s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 671121 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 671121 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]