SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1034139 LIMIT 1 [ RunTime:0.000606s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1034139 [ RunTime:0.001709s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (164103,261819,399490,725312,910810,644895,266810,922452,19733,324310,610806,465352,49706,597161,610239,594704,667354,870882,132525,730428,842600,599321,763939,935149,362499,652993,470191,962266,238144,997698,346471,548958,871094,863576,114292,144983,373820,605183,616374,202071,687789,52810,859634,665483,142968,134235,866295,158792,500736,973536,174965,283320,928231,670697,677456,1035810,109812,415461,757171,1012133) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1034139 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1034139 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]