SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1007239 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1007239 [ RunTime:0.001810s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (593501,819502,688029,593453,127503,666564,487374,107996,140687,141593,291616,1036172,652318,883527,230861,984440,542128,368794,64191,905510,270606,956808,451472,748855,273429,297610,813508,383229,460460,438191,297708,239842,762152,1019869,632058,577852,869306,394045,917936,197138,643124,236900,923307,961513,155230,671740,811014,381339,806580,446484,804750,692548,259027,857167,162549,212839,704980,479335,796553,359977) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1007239 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1007239 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000639s ]