SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043673 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043673 [ RunTime:0.001932s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1024974,842768,765123,388024,500377,609744,1002289,541943,513775,255172,897880,726369,424285,569822,15162,739418,649352,741829,1042782,117461,566983,601652,360311,203255,476142,510388,429736,457085,713281,519282,420670,728259,794558,487720,121949,680234,275705,703202,854197,3817,381638,595872,249576,486336,398248,355174,519498,131911,22154,466974,380034,228075,607424,574821,831320,675411,239974,535545,725825,78043) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001319s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043673 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000511s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043673 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]